MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

19 rows where Artist Alpha Sort = 5255

View and edit SQL

Suggested facets: Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Artist Begin Date (date), Artist End Date (date)

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
66417 1996.61.1 0 0 78941 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 ca. 1972 1967 1977 synthetics 15103   Gift of Roz Gerten Jacobs, 1996                           Metropolitan Museum of Art, New York, NY 1
67155 1995.153.5 0 0 79762 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 1960s 1960 1969 feathers, synthetics 15329   Gift of Mrs. Morton J. Seifter, 1995                           Metropolitan Museum of Art, New York, NY 1
67674 1994.279.1 0 0 80379 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 1960–79 1960 1979 synthetic, chicken feathers 15412   Gift of Mrs. Anne Markley Spivak, 1994                           Metropolitan Museum of Art, New York, NY 1
73732 1985.379.7 0 0 92210 Costume Institute 8 Coatdress 5934 Coatdress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 ca. 1968 1963 1973 feathers, synthetic 16816   Gift of Mrs. Anne Markley Spivak, 1985                           Metropolitan Museum of Art, New York, NY 1
73734 1974.68.3 0 0 92212 Costume Institute 8 Cocktail Dress 5933 Cocktail dress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 1970 1970 1970 [no medium available] 15100   Gift of Mrs. T. Suffern Tailer, 1974                           Metropolitan Museum of Art, New York, NY 1
73735 1982.419.6a, b 0 0 92213 Costume Institute 8 Evening ensemble 5879 Evening ensemble American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 ca. 1958 1953 1963 silk 15101   Gift of Charles Hollerith in memory of his wife, Helen M. Hollerith, 1982                           Metropolitan Museum of Art, New York, NY 1
73736 1985.379.6 0 0 92214 Costume Institute 8 Dress 5877 Dress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 mid-1970s 1973 1977 wool 15104   Gift of Mrs. Anne Markley Spivak, 1985                           Metropolitan Museum of Art, New York, NY 1
73737 1978.69 0 0 92215 Costume Institute 8 Cocktail Dress 5933 Cocktail dress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 1968–70 1968 1970 nylon, rayon 15669   Gift of Estelle Mevorach, 1978                           Metropolitan Museum of Art, New York, NY 1
73971 2003.256.14 0 0 93621 Costume Institute 8 Evening dress 5874 "Monkey Dress" American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 ca. 1972 1968 1978 silk, wool, plastic 16884   Gift of Laura Johnson, 2003                           Metropolitan Museum of Art, New York, NY 1
75045 1982.419.8a–c 0 0 96140 Costume Institute 8 Evening ensemble 5879 Evening ensemble American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 ca. 1970 1965 1975 silk, fur 15225   Gift of Charles Hollerith in memory of his wife, Helen M. Hollerith, 1982                           Metropolitan Museum of Art, New York, NY 1
75046 1975.301.14 0 0 96141 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 1962–75 1962 1975 wool, glass 15464   Gift of Mrs. Mortimer Solomon, 1975                           Metropolitan Museum of Art, New York, NY 1
75047 1980.594.6 0 0 96142 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 ca. 1963 1958 1968 silk, plastic 15181   Gift of Mrs. Samuel P. Peabody, 1980                           Metropolitan Museum of Art, New York, NY 1
75048 1982.430.2 0 0 96143 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 ca. 1965 1960 1970 silk 15101   Gift of Mrs. Joseph B. Ziegler, 1982                           Metropolitan Museum of Art, New York, NY 1
75049 C.I.68.11.1 0 0 96144 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 1967 1967 1967 silk, feathers 15141   Gift of Donald Brooks, Inc., 1968                           Metropolitan Museum of Art, New York, NY 1
75097 1976.256.1a, b 0 0 96203 Costume Institute 8 Dress  6290 Dress American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 1962 1962 1962 wool 15104   Gift of Lee Siegel Blaufarb, 1976                           Metropolitan Museum of Art, New York, NY 1
78720 1990.258.4a–c 0 0 104799 Costume Institute 8 Evening pajamas 6178 Evening pajamas American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 1968–70 1968 1970 silk, glass, metal 16024   Gift of Mrs. Garrick C. Stephenson, 1990                           Metropolitan Museum of Art, New York, NY 1
83456 1987.266.2a, b 0 0 115770 Costume Institute 8 Evening shoes 5884 Evening shoes American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 1969 1969 1969 silk, leather 15154   Gift of Jeanine Larmouth, 1987                           Metropolitan Museum of Art, New York, NY 1
85137 1985.379.5a–d 0 0 119467 Costume Institute 8 Ensemble 5875 Ensemble American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 1970–75 1970 1975 wool 15104   Gift of Mrs. Anne Markley Spivak, 1985                           Metropolitan Museum of Art, New York, NY 1
86870 1972.157 0 0 123036 Costume Institute 8 Coat 4973 Coat American 1         Designer 5   Donald Brooks American, New Haven, Connecticut 1928–2005 Stony Brook, New York   Brooks, Donald 5255 American 1 1928-01-10 2005-08-01 1970 1970 1970 fur 15347   Gift of Miss Sally Krell, 1972                           Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 132.178ms · Data license: CC0 · Data source: metmuseum/openaccess